Tabela Address

Definicja tabeli Address

Name

Address

Code

Address

Comment

PL: Tabela adresów
EN: Address table
DE: Die Tabelle fur die Adresse


Lista kolumn tabeli Address

Name

Code

AddressID

AddressID

PostOfficeID

PostOfficeID

VoivodshipID

VoivodshipID

CountryID

CountryID

AddressTypeID

AddressTypeID

AdmCodeID

AdmCodeID

PlaceID

PlaceID

Street

Street

FlatNo

FlatNo

PostalCode

PostalCode

PostOffice

PostOffice

Place

Place

Commune

Commune

District

District

Voivodship

Voivodship

Country

Country

Phone

Phone

Fax

Fax

www

www

Telex

Telex

Detailed

Detailed

DescriptiveAddress

DescriptiveAddress

Email

Email

HomeNo

HomeNo

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

MapCoordinateX

MapCoordinateX

MapCoordinateY

MapCoordinateY

BlockNo

BlockNo

KLADR

KLADR

Comments

Comments


Kolumna AddressID tabeli Address

Definicja kolumny AddressID tabeli Address

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna PostOfficeID tabeli Address

Definicja kolumny PostOfficeID tabeli Address

Name

PostOfficeID

Code

PostOfficeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VoivodshipID tabeli Address

Definicja kolumny VoivodshipID tabeli Address

Name

VoivodshipID

Code

VoivodshipID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CountryID tabeli Address

Definicja kolumny CountryID tabeli Address

Name

CountryID

Code

CountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AddressTypeID tabeli Address

Definicja kolumny AddressTypeID tabeli Address

Name

AddressTypeID

Code

AddressTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AdmCodeID tabeli Address

Definicja kolumny AdmCodeID tabeli Address

Name

AdmCodeID

Code

AdmCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna PlaceID tabeli Address

Definicja kolumny PlaceID tabeli Address

Name

PlaceID

Code

PlaceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Street tabeli Address

Definicja kolumny Street tabeli Address

Name

Street

Code

Street

Data Type

VARCHAR2(90)

Mandatory

No

Comment

 


Kolumna FlatNo tabeli Address

Definicja kolumny FlatNo tabeli Address

Name

FlatNo

Code

FlatNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna PostalCode tabeli Address

Definicja kolumny PostalCode tabeli Address

Name

PostalCode

Code

PostalCode

Data Type

VARCHAR2(10)

Mandatory

No

Comment

PL: Kod pocztowy
EN: Postal code
DE: Der postalische Code

Wieksza ilosc znaków (>6) jest dla kodów z zagranicy.


Kolumna PostOffice tabeli Address

Definicja kolumny PostOffice tabeli Address

Name

PostOffice

Code

PostOffice

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Urzad pocztowy
EN: Post office
DE: Das postalische Amt


Kolumna Place tabeli Address

Definicja kolumny Place tabeli Address

Name

Place

Code

Place

Data Type

VARCHAR2(56)

Mandatory

No

Comment

PL: Miejscowosc
EN: Place
DE: die Stadt


Kolumna Commune tabeli Address

Definicja kolumny Commune tabeli Address

Name

Commune

Code

Commune

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Gmina


Kolumna District tabeli Address

Definicja kolumny District tabeli Address

Name

District

Code

District

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Powiat


Kolumna Voivodship tabeli Address

Definicja kolumny Voivodship tabeli Address

Name

Voivodship

Code

Voivodship

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Wojewodztwo


Kolumna Country tabeli Address

Definicja kolumny Country tabeli Address

Name

Country

Code

Country

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna Phone tabeli Address

Definicja kolumny Phone tabeli Address

Name

Phone

Code

Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL: Numer telefonu
EN: Telephone number
DE: Die Telefonnummer


Kolumna Fax tabeli Address

Definicja kolumny Fax tabeli Address

Name

Fax

Code

Fax

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL: Numer faxu
EN: Fax number
DE: Die Nummer des Fax


Kolumna www tabeli Address

Definicja kolumny www tabeli Address

Name

www

Code

www

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL; Adres strony www
EN: Web site address
DE: Das Webangebot


Kolumna Telex tabeli Address

Definicja kolumny Telex tabeli Address

Name

Telex

Code

Telex

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Detailed tabeli Address

Definicja kolumny Detailed tabeli Address

Name

Detailed

Code

Detailed

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Szczególy
EN: Detailed information
DE: Die detailliertere Information


Kolumna DescriptiveAddress tabeli Address

Definicja kolumny DescriptiveAddress tabeli Address

Name

DescriptiveAddress

Code

DescriptiveAddress

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Email tabeli Address

Definicja kolumny Email tabeli Address

Name

Email

Code

Email

Data Type

VARCHAR2(70)

Mandatory

No

Comment

 


Kolumna HomeNo tabeli Address

Definicja kolumny HomeNo tabeli Address

Name

HomeNo

Code

HomeNo

Data Type

VARCHAR2(16)

Mandatory

No

Comment

PL: Numer domu
EN: House number
DE: Die Nummer des Haus


Kolumna InsertDate tabeli Address

Definicja kolumny InsertDate tabeli Address

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli Address

Definicja kolumny InsertingPerson tabeli Address

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli Address

Definicja kolumny LastModifiedDT tabeli Address

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli Address

Definicja kolumny LastModifiedPerson tabeli Address

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MapCoordinateX tabeli Address

Definicja kolumny MapCoordinateX tabeli Address

Name

MapCoordinateX

Code

MapCoordinateX

Data Type

VARCHAR2(16)

Mandatory

No

Comment

okresla dlugosc geograficzna


Kolumna MapCoordinateY tabeli Address

Definicja kolumny MapCoordinateY tabeli Address

Name

MapCoordinateY

Code

MapCoordinateY

Data Type

VARCHAR2(16)

Mandatory

No

Comment

okresla szerokosc geograficzna


Kolumna BlockNo tabeli Address

Definicja kolumny BlockNo tabeli Address

Name

BlockNo

Code

BlockNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Numer budynku nieprzylegajacego do ulicy. W Rosji tego typu budynku posiadaja
HomeNo identyczne do budynku znajdujacego sie przy ulicy, ale róznia sie
numerem budynku.


Kolumna KLADR tabeli Address

Definicja kolumny KLADR tabeli Address

Name

KLADR

Code

KLADR

Data Type

VARCHAR2(17)

Mandatory

No

Comment

Kod podzialu administracyjnego w Rosji


Kolumna Comments tabeli Address

Definicja kolumny Comments tabeli Address

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Uwagi do adresu


Lista kluczy tabeli Address

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Address

Definicja klucza Identifier_1 tabeli Address

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment